﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace WaveMaster.Holidays.Club.SQL
{
    public class ConfigurationSQL
    {
        public static string GetConfigurationtByName()
        {
            string sql = "select * from configuration where config_name = ?config_name ";
            return sql;
        }
        public static string InsertSeaPort()
        {
            string sql = @"INSERT INTO configuration
           (config_name
           ,value_1
            ,value_2
            ,value_3
           ,value_4           
            )
     VALUES
           (?config_name
           ,?value_1
            ,?value_2
            ,?value_3
            ,?value_4
           )";
            return sql;
        }
        public static string UpdateSeaPort()
        {
            string sql = @"UPDATE configuration
   SET config_name=?config_name
           ,value_1=?value_1
            ,value_2=?value_2
            ,value_3=?value_3
            ,value_4=?value_4
 WHERE idconfiguration = ?idconfiguration";
            return sql;
        }
    }
}
